You are here: 1. Distribution System > 1.9. REPORTS Menu > 1.9.2. Reports - Report Generator > 1.9.2.7. Report Generator - Edit Menu > Edit - Add Field > Adding a Drill for a Variable Field 
Adding a Drill for a Variable Field 

Variables in reports can have drills associated with them. Drills are used to go further into reports, by drilling into a more detailed report from the output of the initial report. Drills can only be used if the report is sent to the screen. They appear as red text on the screen.

Drills can also be used to run a file update program to update data, e.g. in the Debtor master file or Item master file.

To add a drill for a variable field:

  1. Complete the steps for adding a variable field.

Refer to "Adding Variable Fields".

  1. Select the Drill button.

Micronet displays the Edit Drills screen.

  1. If you want to:

If you are adding or editing a drill, Micronet displays the Add/Edit Drill screen.

  1. Check one of the following boxes at the bottom of the screen depending on what you want your drill to do:
  1. Complete the following fields:

 

Field

Value

 

Report Name / File Update

The name of this field depends on the option selected in the previous step.

Enter the name of the report or file update procedure to drill into. You can also press spacebar then Enter to select a report or file update procedure.

 

Group Name

For reports only, enter the report group.

 

Condition

 

 

Type

 

 

Field

 

 

Const

 

 

Question 1, 2, 3

 

  1. Select the Accept button.

Micronet redisplays the Edit Drills screen showing the drills for the report.

  1. Repeat the steps above to add more drills for the variable field if required.
  2. When you have finished maintaining drills for your variable field, select the OK button.

Micronet redisplays the Edit Variable screen.